You can import data into the system database using the Import functionality accessed in all configurable forms except the following:
Console Softkeys
Console Softkeys -> Softkeys
Device Connectivity - All
Device Connectivity - Moved
DHCP Lease Viewer
Dimension Selection
Embedded Media Sources -> Embedded Media Source Usage
License and Option Selection
MiXML Applications
MiXML Applications -> MiXML Application Features
VM Network Users
Personal Speed Calls
Personal Speed Calls -> Speed Calls
Restore
Shared Form Configuration
System Audio Source Update
System Diagnostics Reporting
Importing data can save you considerable configuration time, and reduces the likelihood of data-entry errors.
This functionality is valuable
for adding user and device data during initial system configuration (that is, when you are installing and configuring a new system).
when you wish to add a large number of new users to an existing system database.
The data is entered into a Microsoft® Excel spreadsheet supplied with MiVoice Business (see Obtaining the Import Spreadsheet) and saved as .CSV files for import. You can also import an existing spreadsheet of configuration data in .CSV format provided it is in the appropriate format, as described in Import Spreadsheet.
You need a Zip archive application like WinZip® installed on your client station in order to open the Import Spreadsheet form after downloading it.
You need Microsoft® Excel 97 (SR-2), Excel 2000 (SP 3), Excel 2003 (SP 2) or higher installed on your client station in order to download and read the Import Spreadsheet form, and to manipulate the data to be imported to the system database.
For CSV files containing characters in the extended ASCII character set—that is, characters above 128—use UTF-8 file encoding when saving the file. In Microsoft Excel, select 'Unicode Text' instead of 'CSV (Comma Delimited)' from the Save As Type file-type list. Also ensure that the file extension is CSV not TXT.
If using Internet Explorer 9 (IE9) on Windows 7, ensure that you have the corresponding 32-bit or 64-bit Java plugin installed. The version of IE9 installed with Windows 7 Pro is 64-bit.
NOTE: You may need to change the security settings in Internet Explorer to allow file imports. If you get a "C:\fakepath" or similar error message while attempting an import, follow these instructions,
Click Tools > Internet Options > Security > Trusted sites > Sites.
Enter the IP address of the MiVoice Business system as: https://<IP Address>
Click Add.
Click Close.
Click Custom level... and enable the following options:
ActiveX controls and plug-ins > Automatic prompting for ActiveX controls
Downloads > Automatic prompting for file downloads
Click OK, and then OK again to save the changes.
Exit Internet Explorer, and then restart it.
Retry the file import.